alter table ClientPackage
add PackageId int not null
go
ALTER TABLE [dbo].[ClientPackage]  WITH CHECK ADD  CONSTRAINT [FK_ClientPackage_TravelPackage] FOREIGN KEY([PackageId])
REFERENCES [dbo].[TravelPackage] ([PackageId])
GO
ALTER TABLE [dbo].[ClientPackage] CHECK CONSTRAINT [FK_ClientPackage_TravelPackage]
GO
alter table ClientPackage
alter column PkgDestId int null
go